The data source for this project is the United Nations SDG Indicator Database

This Post Adresses 2 Main Questions:

  1. What proportion of Sustainable Development Goal (SDG) Indicator Data is missing for each Small Island Developing State (SIDS)?

  2. How recent is the available data?

Missing Data

In the na_heat_map.Rmd

  • Data is read in, one goal at a time
  • The data is cleaned
  • The median value is calculated for each SDG Indicator and SIDS
  • The data is joined
  • A heat map is created visualizing Missing SDG Data for SIDS, (measured in % of Missing Data per Goal)

This is the result

f <- pheatmap(sdg_na_percentages_matrix, treeheight_row = 0, treeheight_col = 0, display_numbers = TRUE, fontsize_number = 6, angle_col = 45, na_col = "red", main = "Missing SDG Data for SIDS, (measured in % of Missing Data per Goal)")

Visualization Summary
  • How to interpret
    • When looking at the top left box, we see that Trinidad and Tobago is missing 29% of the indicator data for SDG 7
      • Goal 7 is to Ensure Access to affordable, reliable, sustainable and modern energy for all
      • Goal 7 has six indicators including
        • Proportion of population with access to electricity, Renewable energy share in the total final energy consumption, etc..
      • Trinidad and Tobago has data for 4 of the 6 indicators
  • Overall Picture
    • A significant amount of data is missing
    • Many SIDS are missing data for over 80% of the indicators for some SDG’s
      • Goal 7 has the least amount of missing data
      • Goal 5, Gender Equality, has the most amount of missing data
      • Goal 3, Good Health and Well-Being, and Goal 11, Sustainable Cities and Communities seem to have the most variance in misssing data among SIDS
      • New Caledonia, French Polynesia, American Samoa, Guam, The Norhtern Mariana Islands, Sint Maarten, The U.S Virgin Islands, Bonaire Sint Eustatius and Saba, Aruba Curracao, The British Virgin Islands, Montserrat, Anguilla, Puerto Rico, and Niue hav ethe most missind gata across all SDG’s
  • Limitations

Most Recent Year Data was Collected

p